<?php
	namespace org\kahikai\database\mysql;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Cp1252"/>
<meta name="author" content="Ch4mp"/>
<link rel="shortcut icon" href="../../../../../favicon.ico" type="image/x-icon"/> 
<link rel="icon" href="../../../../../favicon.ico" type="image/x-icon"/>
<title>MysqlAliasDao test</title>
</head>
<body>
<?php
	require_once '../../../../../org/kahikai/database/mysql/MysqlAliasDao.php';
	require_once '../../../../../org/kahikai/database/mysql/MysqlLanguageDao.php';
	
	use org\kahikai\database\mysql\MysqlAliasDao;
	use org\kahikai\database\mysql\MysqlLanguageDao;
	
	session_start();
	
	if(!isset($_SESSION['languageDao'])) {
		$_SESSION['languageDao'] = new MysqlLanguageDao();
	}
	if(!isset($_SESSION['aliasDao'])) {
		$_SESSION['aliasDao'] = new MysqlAliasDao($_SESSION['languageDao']);
	}
	
	echo "<h1>getByGeneId(1)</h1>\n";
	echo "<p>";
	foreach($_SESSION['aliasDao']->getByGeneId(1) as $alias) {
		$lang = $alias->language->iso2;
		echo "$alias->name ($lang)<br/>\n";
	}
	echo "</p>\n";
	
	echo "<h1>getByGeneId(-1)</h1>\n";
	echo "<p>";
	foreach($_SESSION['aliasDao']->getByGeneId(-1) as $alias) {
		$lang = $alias->language->iso2;
		echo "$alias->name ($lang)<br/>\n";
	}
	echo "</p>\n";
	
	echo "<h1>getBySpeciesId(1)</h1>\n";
	echo "<p>";
	foreach($_SESSION['aliasDao']->getBySpeciesId(1) as $alias) {
		$lang = $alias->language->iso2;
		echo "$alias->name ($lang)<br/>\n";
	}
	echo "</p>\n";
	
	echo "<h1>getBySpeciesId(-1)</h1>\n";
	echo "<p>";
	foreach($_SESSION['aliasDao']->getBySpeciesId(-1) as $alias) {
		$lang = $alias->language->iso2;
		echo "$alias->name ($lang)<br/>\n";
	}
	echo "</p>\n";
?>
</body>
</html>